AWS RDS 인증서 갱신 시 재시동이 필요한 DB 엔진을 알아보자!
안녕하세요! 클래스메소드 금상원 입니다. 이번 블로그에서는 AWS RDS의 인증서 버전을 갱신 시 재시동이 필요한 DB 엔진이 무엇인지 알아보는 방법에 대해 소개하도록 하겠습니다.
개요
기존에 AWS RDS의 인증서 버전을「rds-ca-2019」을 사용 중인 분들께서는 인증서의 유효기간이 2024년8월22일에 만료되기 때문에 인증서 갱신이 필요합니다.
하지만 갱신 시 AWS RDS 를 재시동 해야 하는 DB 엔진버전이 있기 때문에 다운타임을 대비하기 위해 미리 알아보는 방법을 알아보겠습니다.
재시동이 필요한 DB 엔진버전 알아보기
aws rds describe-db-engine-versions \ --query "DBEngineVersions[?SupportsCertificateRotationWithoutRestart==\`false\`].[Engine, EngineVersion, DBEngineDescription]"
위의 명령어를 입력하면 재시동이 필요한 DB 엔진이 나타납니다.
2024년06월06일 검색결과 재시동이 필요한 DB 엔진은 아래의「재시동이 필요한 DB 엔진 확인해 보기」를 클릭하여 확인해 주세요.
확인 방법으로는「command+f」나「ctrl+f」를 이용하여 DB 엔진 명을 검색해서 찾으시면 편리 합니다.
재시동이 필요한 DB 엔진 확인해 보기
[ [ "aurora-mysql", "5.7.mysql_aurora.2.11.4", "Aurora MySQL" ], [ "docdb", "3.6.0", "Amazon DocumentDB (with MongoDB compatibility)" ], [ "docdb", "4.0.0", "Amazon DocumentDB (with MongoDB compatibility)" ], [ "docdb", "5.0.0", "Amazon DocumentDB (with MongoDB compatibility)" ], [ "custom-sqlserver-ee", "15.00.4073.23.v1", "Microsoft SQL Server Enterprise Edition for custom RDS" ], [ "custom-sqlserver-ee", "15.00.4249.2.v1", "Microsoft SQL Server Enterprise Edition for custom RDS" ], [ "custom-sqlserver-ee", "15.00.4261.1.v1", "Microsoft SQL Server Enterprise Edition for custom RDS" ], [ "custom-sqlserver-ee", "15.00.4312.2.v1", "Microsoft SQL Server Enterprise Edition for custom RDS" ], [ "custom-sqlserver-ee", "15.00.4322.2.v1", "Microsoft SQL Server Enterprise Edition for custom RDS" ], [ "custom-sqlserver-ee", "15.00.4345.5.v1", "Microsoft SQL Server Enterprise Edition for custom RDS" ], [ "custom-sqlserver-ee", "16.00.4085.2.v1", "Microsoft SQL Server Enterprise Edition for custom RDS" ], [ "custom-sqlserver-se", "15.00.4073.23.v1", "Microsoft SQL Server Standard Edition for custom RDS" ], [ "custom-sqlserver-se", "15.00.4249.2.v1", "Microsoft SQL Server Standard Edition for custom RDS" ], [ "custom-sqlserver-se", "15.00.4261.1.v1", "Microsoft SQL Server Standard Edition for custom RDS" ], [ "custom-sqlserver-se", "15.00.4312.2.v1", "Microsoft SQL Server Standard Edition for custom RDS" ], [ "custom-sqlserver-se", "15.00.4322.2.v1", "Microsoft SQL Server Standard Edition for custom RDS" ], [ "custom-sqlserver-se", "15.00.4345.5.v1", "Microsoft SQL Server Standard Edition for custom RDS" ], [ "custom-sqlserver-se", "16.00.4085.2.v1", "Microsoft SQL Server Standard Edition for custom RDS" ], [ "custom-sqlserver-web", "15.00.4073.23.v1", "Microsoft SQL Server Web Edition for custom RDS" ], [ "custom-sqlserver-web", "15.00.4249.2.v1", "Microsoft SQL Server Web Edition for custom RDS" ], [ "custom-sqlserver-web", "15.00.4261.1.v1", "Microsoft SQL Server Web Edition for custom RDS" ], [ "custom-sqlserver-web", "15.00.4312.2.v1", "Microsoft SQL Server Web Edition for custom RDS" ], [ "custom-sqlserver-web", "15.00.4322.2.v1", "Microsoft SQL Server Web Edition for custom RDS" ], [ "custom-sqlserver-web", "15.00.4345.5.v1", "Microsoft SQL Server Web Edition for custom RDS" ], [ "custom-sqlserver-web", "16.00.4085.2.v1", "Microsoft SQL Server Web Edition for custom RDS" ], [ "db2-ae", "11.5.9.0.sb00000000.r1", "Db2 Advanced Edition" ], [ "db2-ae", "11.5.9.0.sb00039210.r1", "Db2 Advanced Edition" ], [ "db2-ae", "11.5.9.0.sb00039340.r1", "Db2 Advanced Edition" ], [ "db2-ae", "11.5.9.0.sb00040222.r1", "Db2 Advanced Edition" ], [ "db2-ae", "11.5.9.0.sb00040226.r1", "Db2 Advanced Edition" ], [ "db2-se", "11.5.9.0.sb00000000.r1", "Db2 Standard Edition" ], [ "db2-se", "11.5.9.0.sb00039210.r1", "Db2 Standard Edition" ], [ "db2-se", "11.5.9.0.sb00039340.r1", "Db2 Standard Edition" ], [ "db2-se", "11.5.9.0.sb00040222.r1", "Db2 Standard Edition" ], [ "db2-se", "11.5.9.0.sb00040226.r1", "Db2 Standard Edition" ], [ "neptune", "1.1.0.0", "neptune" ], [ "neptune", "1.1.1.0", "neptune" ], [ "neptune", "1.2.0.0", "neptune" ], [ "neptune", "1.2.0.1", "neptune" ], [ "neptune", "1.2.0.2", "neptune" ], [ "neptune", "1.2.1.0", "neptune" ], [ "neptune", "1.2.1.1", "neptune" ], [ "neptune", "1.3.0.0", "neptune" ], [ "neptune", "1.3.1.0", "neptune" ], [ "aurora-postgresql", "13.12", "Aurora (PostgreSQL)" ], [ "mysql", "5.7.44", "MySQL Community Edition" ], [ "mysql", "5.7.44-rds.20240408", "MySQL Community Edition" ], [ "sqlserver-ee", "13.00.6300.2.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "13.00.6419.1.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "13.00.6430.49.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "13.00.6435.1.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "14.00.3281.6.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "14.00.3294.2.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "14.00.3356.20.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "14.00.3381.3.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "14.00.3401.7.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "14.00.3421.10.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "14.00.3451.2.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "14.00.3460.9.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "14.00.3465.1.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "15.00.4043.16.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "15.00.4073.23.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "15.00.4153.1.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "15.00.4198.2.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "15.00.4236.7.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "15.00.4312.2.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "15.00.4316.3.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "15.00.4322.2.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "15.00.4335.1.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "15.00.4345.5.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "15.00.4355.3.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "15.00.4365.2.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "16.00.4085.2.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "16.00.4095.4.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "16.00.4105.2.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "16.00.4115.5.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "16.00.4120.1.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ee", "16.00.4125.3.v1", "Microsoft SQL Server Enterprise Edition" ], [ "sqlserver-ex", "13.00.6300.2.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "13.00.6419.1.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "13.00.6430.49.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "13.00.6435.1.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "14.00.3281.6.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "14.00.3294.2.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "14.00.3356.20.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "14.00.3381.3.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "14.00.3401.7.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "14.00.3421.10.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "14.00.3451.2.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "14.00.3460.9.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "14.00.3465.1.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "15.00.4043.16.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "15.00.4073.23.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "15.00.4153.1.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "15.00.4198.2.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "15.00.4236.7.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "15.00.4312.2.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "15.00.4316.3.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "15.00.4322.2.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "15.00.4335.1.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "15.00.4345.5.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "15.00.4355.3.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "15.00.4365.2.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "16.00.4085.2.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "16.00.4095.4.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "16.00.4105.2.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "16.00.4115.5.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "16.00.4120.1.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-ex", "16.00.4125.3.v1", "Microsoft SQL Server Express Edition" ], [ "sqlserver-se", "13.00.6300.2.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "13.00.6419.1.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "13.00.6430.49.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "13.00.6435.1.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "14.00.3281.6.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "14.00.3294.2.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "14.00.3356.20.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "14.00.3381.3.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "14.00.3401.7.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "14.00.3421.10.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "14.00.3451.2.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "14.00.3460.9.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "14.00.3465.1.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "15.00.4043.16.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "15.00.4073.23.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "15.00.4153.1.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "15.00.4198.2.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "15.00.4236.7.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "15.00.4312.2.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "15.00.4316.3.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "15.00.4322.2.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "15.00.4335.1.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "15.00.4345.5.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "15.00.4355.3.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "15.00.4365.2.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "16.00.4085.2.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "16.00.4095.4.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "16.00.4105.2.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "16.00.4115.5.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "16.00.4120.1.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-se", "16.00.4125.3.v1", "Microsoft SQL Server Standard Edition" ], [ "sqlserver-web", "13.00.6300.2.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "13.00.6419.1.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "13.00.6430.49.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "13.00.6435.1.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "14.00.3281.6.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "14.00.3294.2.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "14.00.3356.20.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "14.00.3381.3.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "14.00.3401.7.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "14.00.3421.10.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "14.00.3451.2.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "14.00.3460.9.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "14.00.3465.1.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "15.00.4043.16.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "15.00.4073.23.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "15.00.4153.1.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "15.00.4198.2.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "15.00.4236.7.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "15.00.4312.2.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "15.00.4316.3.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "15.00.4322.2.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "15.00.4335.1.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "15.00.4345.5.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "15.00.4355.3.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "15.00.4365.2.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "16.00.4085.2.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "16.00.4095.4.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "16.00.4105.2.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "16.00.4115.5.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "16.00.4120.1.v1", "Microsoft SQL Server Web Edition" ], [ "sqlserver-web", "16.00.4125.3.v1", "Microsoft SQL Server Web Edition" ] ]
(추가로)특정 DB 엔진만 검색하고 싶은 경우
특정 엔진만 검색하여 확인하고 싶으신 분들은아래의 명령어를 이용해 주세요.
아래의 명령어 에서「엔진명」부분에 찾으시는 DB 엔진명을 입력해 주세요.
aws rds describe-db-engine-versions \ --query "DBEngineVersions[?Engine==\`엔진명\`&&SupportsCertificateRotationWithoutRestart==\`false\`].[Engine, EngineVersion, DBEngineDescription]"
예) aurora-mysql DB 엔진명으로 검색하는 경우
aws rds describe-db-engine-versions \ --query "DBEngineVersions[?Engine==\`aurora-mysql\`&&SupportsCertificateRotationWithoutRestart==\`false\`].[Engine, EngineVersion, DBEngineDescription]"
실행결과
[ [ "aurora-mysql", "5.7.mysql_aurora.2.11.4", "Aurora MySQL" ] ]
마무리
이번 블로그를 통해 AWS RDS의 인증서 갱신 시 재시동이 필요한 DB 엔진이 무엇인지 알아보는 방법에 대해 알아보았습니다.
혹시 재시동이 필요한 DB 엔진을 사용하고 계신 분들은 다운타임 과 같은 문제들을 검토하는데에 도움이 되었으면 좋겠습니다.